forum

home / developersection / forums / how to use return keyword in stored procedure in sql server?

Ask Question
Steilla Mitchel

Student

I completed my post-graduation in 2013 in the engineering field. Engineering is the application of science and math to solve problems. Engineers figure out how things work and find practical uses for scientific discoveries. Scientists and inventors often get the credit for innovations that advance the human condition, but it is engineers who are instrumental in making those innovations available to the world. I love pet animals such as dogs, cats, etc.

Follow
Can you answer this question?
Answer

1 Answers

Steilla Mitchel

Steilla Mitchel

08-Nov-2021

Stored Procedure with RETURN keyword:

 The use of RETURN keyword in SQL Stored Procedure is to return the process after executing a specific part of stores procedure. If you have created a large stored procedure and you want to execute or run only some part of that stored procedure and then close execution then you can use the RETURN keyword after that specific part of code that you want to execute. The RETURN keyword return the process of execution after process a specific part of code.

Ex- 

 CREATE PROCEDURE usp_ReturnProcedure
AS
BEGIN
  --SQL statement that you want to processed.
  RETURN;
  --other SQL statements.
END
GO


MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy